-
Re: Help with "Syntax not quite right"
@Ami Veltrie Try this. =IF(Hierarchy@row > 1, INDEX(ANCESTORS(Task@row), 2)) Does this work for you? Kelly1 · -
Re: Any way to update formula criteria with drag-fill
@Chris L After implementing @kowal 's sage advice, consider using a report to then gather your totals. Information from a report can be displayed on a dashboard. Once the report is built (you will gr…1 · -
Re: Help with "Syntax not quite right"
@Ami Veltrie If your formula above works, go for it! Here's an alternative: =IFERROR(IF(AND(Hierarchy@row = 1, CONTAINS("Travel Week Start Date", DESCENDANTS(Task@row))), INDEX(DESCENDANTS(…1 · -
Re: Combo a vlookup/index formula to pull a value from one sheet with cond formatting to another sheet?
Hey @ParkerLeigh Yes, it is possible however it will need a helper column on your Project Plan sheet to accomplish. A checkbox column will work. The helper column formula will do the actual compariso…1 · -
Re: COUNTIFS with NOT / OR plus ISBLANK.
@Saj =COUNTIFS([Unit Name]:[Unit Name], "ABC", [Unit Type]:[Unit Type], "NEW", [Schedule visit]:[Schedule visit], NOT(OR(@cell = "Completed", @cell = "Cancelled&quo…1 ·